gsc_product_module table — gscpm
This table contains information about the installed product modules with appropriate license details. The table includes a recursive join to support product module hierarchies.
Table 8–3 lists the table’s FLA, fields, and foreign keys.
Table 8–3: gsc_product_module table information
|
Table FLA
|
Fields (data type)
|
Foreign keys
|
|
gscpm
|
product_module_obj (Decimal)
product_obj (Decimal)
product_module_code (Character)
product_module_description (Character)
product_module_installed (Logical)
number_of_users (Integer)
db_connection_pf_file (Character)
relative_path (Character)
deployment_type (Character)
parent_product_module_obj (Decimal)
|
product_module_code
product_module_obj
product_obj
|
Table 8–4 gives details of the table’s indexes.
Table 8–4: gsc_product_module index information
|
Index name
|
Elements
|
Type
|
|
XPKgsc_product_module
|
product_module_obj
|
Primary Unique
|
|
XAK1gsc_product_module
|
product_module_code
|
Unique
|
|
XIE1gsc_product_module
|
product_module_description
|
Nonunique
|
|
XIE2gsc_product_module
|
product_obj
product_module_code
|
Nonunique
|
|
XIE3gsc_product_module
|
parent_product_module_obj
product_module_code
|
Nonunique
|